Restoring Backup File to our Database. 5

Step 1. Click on  to download Recsta source script

Download and Extract the Data File. 

Step 2. Assuming you have done Step 1 Successfully. Open SSMS/Right click on Database inside your Object Explorer/on the properties pane, click on Restore Database..

Step 3. Select  Device: as your source/ Click on the three dots  on the right side/ On the Select Backup Devices pane, click on Add/ On the Locate Backup File Select the  BAK file and hit OK

Step 4. In the next small window that will open, click on ‘Add’ to go to the local Backup file folder where you initially saved the source document (Step 1).

Step 5. In the ‘Local Backup File’ folder, click on the source file to restore and then click on ‘Ok’ 

Step 6.  Now, you are back on to the small screen where you clicked on ‘Add’, here just highlight the file you just added by clicking on it and click on ‘Ok’. 

Step 7. Make sure the progress shows a green circle spinning and then shows ‘Done’ as in Step 8.

Step 8. From the Destination Database Dropdowns Select ‘RecSta’ and then you will see an item stated in the restore plan

Step 9. Then click ‘Ok’. This will restore the source database.  Please refer to the below motion screen for detail

[Figure ]






Backup and Restore a SQL Server:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/quickstart-backup-restore-database?view=sql-server-ver15

Restoring Backup File to our Database. 5

Step 1. Click on  to download Recsta source script

Download and Extract the Data File. 

Step 2. Assuming you have done Step 1 Successfully. Open SSMS/Right click on Database inside your Object Explorer/on the properties pane, click on Restore Database..

Step 3. Select  Device: as your source/ Click on the three dots  on the right side/ On the Select Backup Devices pane, click on Add/ On the Locate Backup File Select the  BAK file and hit OK

Step 4. In the next small window that will open, click on ‘Add’ to go to the local Backup file folder where you initially saved the source document (Step 1).

Step 5. In the ‘Local Backup File’ folder, click on the source file to restore and then click on ‘Ok’ 

Step 6.  Now, you are back on to the small screen where you clicked on ‘Add’, here just highlight the file you just added by clicking on it and click on ‘Ok’. 

Step 7. Make sure the progress shows a green circle spinning and then shows ‘Done’ as in Step 8.

Step 8. From the Destination Database Dropdowns Select ‘RecSta’ and then you will see an item stated in the restore plan

Step 9. Then click ‘Ok’. This will restore the source database.  Please refer to the below motion screen for detail

[Figure ]






Backup and Restore a SQL Server:

https://docs.microsoft.com/en-us/sql/relational-databases/backup-restore/quickstart-backup-restore-database?view=sql-server-ver15